object frmDatos: TfrmDatos
  Left = 230
  Top = 115
  Width = 756
  Height = 552
  Caption = 'frmDatos'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Tahoma'
  Font.Style = []
  OldCreateOrder = False
  PixelsPerInch = 96
  TextHeight = 13
  object Label1: TLabel
    Left = 8
    Top = 64
    Width = 47
    Height = 13
    Caption = 'CLIENTES'
  end
  object Label2: TLabel
    Left = 8
    Top = 192
    Width = 62
    Height = 13
    Caption = 'PROVINCIAS'
  end
  object Label3: TLabel
    Left = 8
    Top = 248
    Width = 57
    Height = 13
    Caption = 'LOCALIDAD'
  end
  object Label4: TLabel
    Left = 8
    Top = 304
    Width = 95
    Height = 13
    Caption = 'CONDICION DE IVA'
  end
  object Label5: TLabel
    Left = 208
    Top = 72
    Width = 103
    Height = 13
    Caption = 'TELEFONOS/CLIENTE'
  end
  object Label6: TLabel
    Left = 216
    Top = 144
    Width = 44
    Height = 13
    Caption = 'TENICOS'
  end
  object Label7: TLabel
    Left = 192
    Top = 240
    Width = 54
    Height = 13
    Caption = 'MAQUINAS'
  end
  object Label8: TLabel
    Left = 368
    Top = 80
    Width = 62
    Height = 13
    Caption = 'CONTACTOS'
  end
  object Label9: TLabel
    Left = 16
    Top = 368
    Width = 143
    Height = 13
    Caption = 'VISTA COMPONENTES STOCK'
  end
  object Label10: TLabel
    Left = 224
    Top = 416
    Width = 96
    Height = 13
    Caption = 'TIPO COMPONENTE'
  end
  object Label11: TLabel
    Left = 536
    Top = 376
    Width = 43
    Height = 13
    Caption = 'MONEDA'
  end
  object Label12: TLabel
    Left = 16
    Top = 432
    Width = 44
    Height = 13
    Caption = 'PRECIOS'
  end
  object Label13: TLabel
    Left = 376
    Top = 200
    Width = 103
    Height = 13
    Caption = 'ESTADOS RECLAMOS'
  end
  object Label14: TLabel
    Left = 384
    Top = 264
    Width = 108
    Height = 13
    Caption = 'PRIORIDAD RECLAMO'
  end
  object Label15: TLabel
    Left = 248
    Top = 344
    Width = 54
    Height = 13
    Caption = 'RECLAMOS'
  end
  object Label16: TLabel
    Left = 536
    Top = 32
    Width = 78
    Height = 13
    Caption = 'REPARACIONES'
  end
  object Label17: TLabel
    Left = 544
    Top = 128
    Width = 102
    Height = 13
    Caption = 'LUGAR REPARACION'
  end
  object ZConnection1: TZConnection
    Protocol = 'postgresql-8'
    HostName = 'localhost'
    Port = 5432
    Database = 'sistema_reclamos'
    User = 'postgres'
    Password = 'jhljhl'
    Connected = True
    Left = 8
    Top = 8
  end
  object tblClientes: TZTable
    Connection = ZConnection1
    Active = True
    TableName = 'clientes'
    Left = 8
    Top = 80
    object tblClientescod_cliente: TIntegerField
      FieldName = 'cod_cliente'
      Required = True
    end
    object tblClientesnombre_cliente: TStringField
      FieldName = 'nombre_cliente'
      Required = True
      Size = 40
    end
    object tblClientesapellido_cliente: TStringField
      FieldName = 'apellido_cliente'
      Required = True
      Size = 40
    end
    object tblClientesdomicilio_cliente: TStringField
      FieldName = 'domicilio_cliente'
      Size = 40
    end
    object tblClientesemail_cliente: TStringField
      FieldName = 'email_cliente'
      Size = 40
    end
    object tblClientescliente_activo: TBooleanField
      FieldName = 'cliente_activo'
      Required = True
    end
    object tblClientescod_condicion_iva: TIntegerField
      FieldName = 'cod_condicion_iva'
    end
    object tblClientescod_preventivo: TIntegerField
      FieldName = 'cod_preventivo'
    end
    object tblClientescod_localidad: TIntegerField
      FieldName = 'cod_localidad'
    end
  end
  object dsClientes: TDataSource
    DataSet = tblClientes
    Left = 40
    Top = 80
  end
  object tblProvincia: TZTable
    Connection = ZConnection1
    TableName = 'provincia'
    Left = 8
    Top = 208
    object tblProvinciacod_provincia: TIntegerField
      FieldName = 'cod_provincia'
      Required = True
    end
    object tblProvinciadescripcion_provincia: TStringField
      FieldName = 'descripcion_provincia'
      Required = True
      Size = 40
    end
  end
  object tblLocalidades: TZTable
    Connection = ZConnection1
    TableName = 'localidades'
    Left = 24
    Top = 264
  end
  object tblCondicionIva: TZTable
    Connection = ZConnection1
    TableName = 'condicion_iva'
    Left = 8
    Top = 320
  end
  object qryAltaCliente: TZQuery
    Params = <>
    Left = 96
    Top = 80
  end
  object qryAltaTelefono: TZQuery
    Params = <>
    Left = 208
    Top = 88
  end
  object qryFiltroClientes: TZQuery
    Connection = ZConnection1
    SQL.Strings = (
      'select * from clientes where cliente_activo=true')
    Params = <>
    Left = 8
    Top = 112
  end
  object dsFiltroClientes: TDataSource
    DataSet = qryFiltroClientes
    Left = 40
    Top = 112
  end
  object qryBajaCliente: TZQuery
    Params = <>
    Left = 128
    Top = 80
  end
  object qryObtenerTelefonos: TZQuery
    Params = <>
    Left = 240
    Top = 88
  end
  object qryModificarCliente: TZQuery
    Params = <>
    Left = 160
    Top = 80
  end
  object qryBajaTelefonoCliente: TZQuery
    Params = <>
    Left = 272
    Top = 88
  end
  object qryFiltroTecnico: TZQuery
    Params = <>
    Left = 192
    Top = 160
  end
  object qryAltaTecnico: TZQuery
    Params = <>
    Left = 224
    Top = 160
  end
  object qryBajaTecnico: TZQuery
    Params = <>
    Left = 256
    Top = 160
  end
  object dsFiltroTecnico: TDataSource
    DataSet = qryFiltroTecnico
    Left = 192
    Top = 184
  end
  object qryFiltroMaquinas: TZQuery
    Connection = ZConnection1
    Active = True
    SQL.Strings = (
      
        'select m.nro_serie_pc,c.apellido_cliente,c.nombre_cliente,m.desc' +
        'ripcion_maquina,m.fecha_alta '
      '                                      from maquina m, clientes c'
      '                                      where nro_serie_pc not in '
      
        '                                            (select nro_serie_pc' +
        ' from maquina where fecha_baja <> NULL)'
      
        '                                           and m.cod_cliente=c.c' +
        'od_cliente')
    Params = <>
    Left = 192
    Top = 256
  end
  object dsFiltroMaquinas: TDataSource
    DataSet = qryFiltroMaquinas
    Left = 224
    Top = 256
  end
  object qryAltaMaquina: TZQuery
    Params = <>
    Left = 192
    Top = 288
  end
  object qryBajaMaquina: TZQuery
    Params = <>
    Left = 224
    Top = 288
  end
  object qryModificarMaquina: TZQuery
    Params = <>
    Left = 256
    Top = 288
  end
  object qryAltaContacto: TZQuery
    Params = <>
    Left = 352
    Top = 104
  end
  object qryBajaContacto: TZQuery
    Params = <>
    Left = 384
    Top = 104
  end
  object qryModificarTecnico: TZQuery
    Params = <>
    Left = 288
    Top = 160
  end
  object qryFiltroContactos: TZQuery
    Params = <>
    Left = 352
    Top = 136
  end
  object dsFiltroContactos: TDataSource
    DataSet = qryFiltroContactos
    Left = 352
    Top = 160
  end
  object qryModificarContacto: TZQuery
    Params = <>
    Left = 416
    Top = 104
  end
  object qryConsultaTelefonosContactosCliente: TZQuery
    Params = <>
    Left = 440
    Top = 160
  end
  object qryConsultaContactosCliente: TZQuery
    Params = <>
    Left = 408
    Top = 160
  end
  object dsProvincia: TDataSource
    DataSet = tblProvincia
    OnDataChange = dsProvinciaDataChange
    Left = 40
    Top = 208
  end
  object qryAltaProvincia: TZQuery
    Params = <>
    Left = 72
    Top = 208
  end
  object qryBajaProvincia: TZQuery
    Params = <>
    Left = 104
    Top = 208
  end
  object tblComponentesStock: TZTable
    Connection = ZConnection1
    Active = True
    TableName = 'componentes_stock'
    Left = 16
    Top = 384
    object tblComponentesStocknroserie: TStringField
      FieldName = 'nroserie'
      Size = 30
    end
    object tblComponentesStockdescripcion: TStringField
      FieldName = 'descripcion'
      Size = 40
    end
    object tblComponentesStocktipo: TStringField
      FieldName = 'tipo'
      Size = 40
    end
    object tblComponentesStockcodigotipo: TIntegerField
      FieldName = 'codigotipo'
    end
    object tblComponentesStockcodigomoneda: TIntegerField
      FieldName = 'codigomoneda'
    end
    object tblComponentesStockprecio: TStringField
      FieldName = 'precio'
      Size = 8
    end
  end
  object dsComponentesStock: TDataSource
    DataSet = tblComponentesStock
    OnDataChange = dsComponentesStockDataChange
    Left = 48
    Top = 384
  end
  object tblTipoComponente: TZTable
    Connection = ZConnection1
    TableName = 'tipos_componente'
    Left = 208
    Top = 432
    object tblTipoComponentecod_tipo_componente: TIntegerField
      FieldName = 'cod_tipo_componente'
      Required = True
    end
    object tblTipoComponentedescripcion_tipo_componente: TStringField
      FieldName = 'descripcion_tipo_componente'
      Required = True
      Size = 40
    end
    object tblTipoComponenteactivo: TBooleanField
      FieldName = 'activo'
    end
  end
  object tblMoneda: TZTable
    Connection = ZConnection1
    TableName = 'monedas'
    Left = 536
    Top = 392
    object tblMonedacod_moneda: TIntegerField
      FieldName = 'cod_moneda'
      Required = True
    end
    object tblMonedadescripcion_moneda: TStringField
      FieldName = 'descripcion_moneda'
      Required = True
      Size = 40
    end
    object tblMonedaactivo: TBooleanField
      FieldName = 'activo'
    end
  end
  object qryModificarComponente: TZQuery
    Connection = ZConnection1
    Params = <>
    Left = 240
    Top = 432
  end
  object qryAltaComponente: TZQuery
    Connection = ZConnection1
    Params = <>
    Left = 272
    Top = 432
  end
  object qryBajaComponente: TZQuery
    Connection = ZConnection1
    Params = <>
    Left = 304
    Top = 432
  end
  object qryModificarPrecio: TZQuery
    Params = <>
    Left = 16
    Top = 448
  end
  object tblListaPrecios: TZTable
    Connection = ZConnection1
    TableName = 'lista_precios'
    Left = 48
    Top = 448
    object tblListaPreciosnroserie: TStringField
      FieldName = 'nroserie'
      Size = 30
    end
    object tblListaPrecioscomponente: TStringField
      FieldName = 'componente'
      Size = 40
    end
    object tblListaPrecioscodigomoneda: TIntegerField
      FieldName = 'codigomoneda'
    end
    object tblListaPreciosprecio: TStringField
      FieldName = 'precio'
      Size = 8
    end
  end
  object tblEstadoReclamo: TZTable
    Connection = ZConnection1
    TableName = 'estado_reclamo'
    Left = 376
    Top = 224
    object tblEstadoReclamocod_estado: TIntegerField
      FieldName = 'cod_estado'
      Required = True
    end
    object tblEstadoReclamodescripcion_estado: TStringField
      FieldName = 'descripcion_estado'
      Required = True
      Size = 30
    end
    object tblEstadoReclamoactivo: TBooleanField
      FieldName = 'activo'
    end
  end
  object qryAltaEstadoReclamo: TZQuery
    Connection = ZConnection1
    Params = <>
    Left = 408
    Top = 224
  end
  object qryBajaEstadoReclamo: TZQuery
    Connection = ZConnection1
    Params = <>
    Left = 440
    Top = 224
  end
  object dtsEstadoReclamo: TDataSource
    DataSet = tblEstadoReclamo
    OnDataChange = dtsEstadoReclamoDataChange
    Left = 344
    Top = 224
  end
  object qryBajaMoneda: TZQuery
    Connection = ZConnection1
    Params = <>
    Left = 568
    Top = 392
  end
  object qryAltaMoneda: TZQuery
    Connection = ZConnection1
    Params = <>
    Left = 600
    Top = 392
  end
  object dtsMoneda: TDataSource
    DataSet = tblMoneda
    OnDataChange = dtsMonedaDataChange
    Left = 504
    Top = 392
  end
  object dtsCondicionIVA: TDataSource
    DataSet = tblCondicionIva
    OnDataChange = dtsCondicionIVADataChange
    Left = 40
    Top = 320
  end
  object qryAltaCondicionIVA: TZQuery
    Connection = ZConnection1
    Params = <>
    Left = 72
    Top = 320
  end
  object qryBajaCondicionIVA: TZQuery
    Connection = ZConnection1
    Params = <>
    Left = 104
    Top = 320
  end
  object qryBajaLocalidades: TZQuery
    Connection = ZConnection1
    Params = <>
    Left = 56
    Top = 264
  end
  object qryAltaLocalidades: TZQuery
    Connection = ZConnection1
    Params = <>
    Left = 88
    Top = 264
  end
  object dtsLocalidades: TDataSource
    DataSet = tblLocalidades
    OnDataChange = dtsLocalidadesDataChange
    Left = 65528
    Top = 264
  end
  object dtsPrioridadReclamo: TDataSource
    DataSet = tblPrioridadReclamo
    OnDataChange = dtsPrioridadReclamoDataChange
    Left = 368
    Top = 288
  end
  object tblPrioridadReclamo: TZTable
    Connection = ZConnection1
    TableName = 'prioridad_reclamo'
    Left = 400
    Top = 288
  end
  object qryAltaPrioridadReclamo: TZQuery
    Connection = ZConnection1
    Params = <>
    Left = 440
    Top = 288
  end
  object qryBajaPrioridadReclamo: TZQuery
    Connection = ZConnection1
    Params = <>
    Left = 472
    Top = 288
  end
  object dsTipoComponente: TDataSource
    DataSet = tblTipoComponente
    OnDataChange = dsTipoComponenteDataChange
    Left = 176
    Top = 432
  end
  object qryModificarEstadoReclamo: TZQuery
    Params = <>
    Left = 472
    Top = 224
  end
  object qryModificarMoneda: TZQuery
    Params = <>
    Left = 632
    Top = 392
  end
  object qryModificarPrioridadReclamo: TZQuery
    Params = <>
    Left = 504
    Top = 288
  end
  object qryModificarLocalidad: TZQuery
    Params = <>
    Left = 120
    Top = 264
  end
  object qryFiltroReclamos: TZQuery
    Params = <>
    Left = 224
    Top = 360
  end
  object dsFiltroReclamos: TDataSource
    DataSet = qryFiltroReclamos
    OnDataChange = dsFiltroReclamosDataChange
    Left = 256
    Top = 360
  end
  object qryAltaReclamo: TZQuery
    Params = <>
    Left = 288
    Top = 360
  end
  object qryModificarEstado: TZQuery
    Params = <>
    Left = 320
    Top = 360
  end
  object qryModificarTurno: TZQuery
    Params = <>
    Left = 352
    Top = 360
  end
  object qryListadoTurnosDia: TZQuery
    Params = <>
    Left = 384
    Top = 360
  end
  object dsListadoTurnosDia: TDataSource
    DataSet = qryListadoTurnosDia
    Left = 384
    Top = 392
  end
  object qryActualizarPrioridades: TZQuery
    Params = <>
    Left = 416
    Top = 360
  end
  object qryReparaciones: TZQuery
    Params = <>
    Left = 544
    Top = 48
  end
  object dsReparaciones: TDataSource
    DataSet = qryReparaciones
    OnDataChange = dsReparacionesDataChange
    Left = 576
    Top = 48
  end
  object tblLugarReparacion: TZTable
    Connection = ZConnection1
    TableName = 'lugar_reparacion'
    Left = 560
    Top = 144
    object tblLugarReparacioncod_lugar: TIntegerField
      FieldName = 'cod_lugar'
      Required = True
    end
    object tblLugarReparaciondescripcion_lugar: TStringField
      FieldName = 'descripcion_lugar'
      Required = True
      Size = 30
    end
    object tblLugarReparacionactivo: TBooleanField
      FieldName = 'activo'
    end
  end
  object qryAltaReparacion: TZQuery
    Params = <>
    Left = 616
    Top = 48
  end
  object tblReclamos: TZTable
    Connection = ZConnection1
    TableName = 'reclamos'
    Left = 192
    Top = 360
    object tblReclamoscod_reclamo: TIntegerField
      FieldName = 'cod_reclamo'
      Required = True
    end
    object tblReclamoscod_cliente: TIntegerField
      FieldName = 'cod_cliente'
      Required = True
    end
    object tblReclamosfecha_reclamo: TDateTimeField
      FieldName = 'fecha_reclamo'
      Required = True
    end
    object tblReclamoscod_estado: TIntegerField
      FieldName = 'cod_estado'
      Required = True
    end
    object tblReclamoscod_prioridad: TIntegerField
      FieldName = 'cod_prioridad'
      Required = True
    end
    object tblReclamosdescripcion_problema: TStringField
      FieldName = 'descripcion_problema'
      Required = True
      Size = 140
    end
    object tblReclamosfecha_turno: TDateField
      FieldName = 'fecha_turno'
    end
    object tblReclamoshora_turno: TTimeField
      FieldName = 'hora_turno'
    end
    object tblReclamospreventivo: TBooleanField
      FieldName = 'preventivo'
      Required = True
    end
  end
  object tblMaquinas: TZTable
    Connection = ZConnection1
    TableName = 'maquina'
    Left = 256
    Top = 256
    object tblMaquinasnro_serie_pc: TStringField
      FieldName = 'nro_serie_pc'
      Required = True
      Size = 30
    end
    object tblMaquinascod_cliente: TIntegerField
      FieldName = 'cod_cliente'
      Required = True
    end
    object tblMaquinasdescripcion_maquina: TStringField
      FieldName = 'descripcion_maquina'
      Required = True
      Size = 100
    end
    object tblMaquinasfecha_alta: TDateField
      FieldName = 'fecha_alta'
    end
    object tblMaquinasfecha_baja: TDateField
      FieldName = 'fecha_baja'
    end
  end
  object qryModificarCondicion: TZQuery
    Params = <>
    Left = 136
    Top = 320
  end
  object qryModificarProvincia: TZQuery
    Params = <>
    Left = 136
    Top = 208
  end
  object qryAltaComponenteReparacion: TZQuery
    Params = <>
    Left = 648
    Top = 48
  end
  object qryHistorialReparaciones: TZQuery
    Params = <>
    Left = 288
    Top = 256
  end
end
